﻿CREATE TABLE [dbo].[Grants]
(
[OID] [bigint] NOT NULL IDENTITY(1, 1),
[Version] [timestamp] NOT NULL,
[CaseID] [bigint] NOT NULL,
[ApplicantID] [bigint] NOT NULL,
[ValueOfGrant] [decimal] (11, 2) NOT NULL,
[CheckNumber] [int] NULL,
[NameOnCreditCard] [varchar] (128) NULL,
[GrantTypeID] [bigint] NOT NULL,
[StateID] [bigint] NOT NULL,
[PaymentTypeID] [bigint] NOT NULL,
[DeliveryMethodID] [bigint] NOT NULL,
[DeliverToPersonID] [bigint] NULL,
[DeliverToAddressID] [bigint] NULL,
[Approver1] [bigint] NULL,
[ApprovalDate1] [datetime] NULL,
[Approver2] [bigint] NULL,
[ApprovalDate2] [datetime] NULL,
[DisbursedBy] [bigint] NULL,
[DispersalDate] [datetime] NULL,
[VerifiedBy] [bigint] NULL,
[VerificationDate] [datetime] NULL,
[UpdatedDate] [datetime] NOT NULL,
[CreatedDate] [datetime] NOT NULL
) ON [PRIMARY]


